SELECT *, CASE WHEN `name` LIKE "chapel hill%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "chapel hill" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "chapel hill" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "chapel hill" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NC" AND (locality IN ("chapel hill") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NC" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$6,800,00032602 ArchdaleChapel Hill NC 27517View Listing
$5,195,000329 Tenney CirChapel Hill NC 27514View Listing
$4,750,000131 Winsome LnChapel Hill NC 27516View Listing
$4,425,0008430 Orange Grove RdChapel Hill NC 27516View Listing
$4,250,000729 E Franklin StChapel Hill NC 27514View Listing
$3,799,000317 N Boundary StChapel Hill NC 27514View Listing
$3,475,000620 E Franklin StChapel Hill NC 27514View Listing
$2,950,000130 Cross Creek DrChapel Hill NC 27514View Listing
$2,750,0003 Lanier DrChapel Hill NC 27517View Listing
$2,600,00011103 Governors DrChapel Hill NC 27517View Listing
$2,600,00040002 WorthChapel Hill NC 27517View Listing
$2,500,000Tbd Farrington Point Rd Lot 1Chapel Hill NC 27517View Listing
$2,250,00012085 MoreheadChapel Hill NC 27517View Listing
$2,175,00032515 ArchdaleChapel Hill NC 27517View Listing
$2,150,000105 Founders Ridge DrChapel Hill NC 27517View Listing
$2,150,0001817 N Lakeshore DrChapel Hill NC 27514View Listing
$2,000,00094 W Beech Slope CtChapel Hill NC 27517View Listing
$2,000,000508 Willowbend DrChapel Hill NC 27517View Listing
$1,999,90012014 IredellChapel Hill NC 27517View Listing
$1,995,00090118 HoeyChapel Hill NC 27517View Listing
$1,975,000162 W Beech Slope CtChapel Hill NC 27517View Listing
$1,950,00010331 NashChapel Hill NC 27517View Listing
$1,875,000140 Old Legacy LnChapel Hill NC 27516View Listing
$1,875,000101 Botanical WayChapel Hill NC 27517View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 12:46:24 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NC" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah